{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Model1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":48,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Model1","index":0,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Portfolio selection model"]
[]
["Stock input data"]
[null,"Stock 1","Stock 2","Stock 3"]
["Mean return",0.14000000000000001,0.11,0.1]
["StDev of return",0.2,0.15,0.08]
[]
["Correlations","Stock 1","Stock 2","Stock 3",null,"Covariances","Stock 1","Stock 2","Stock 3"]
["Stock 1",1,0.6,0.4,null,"Stock 1",{"$f":"HLOOKUP($F9,$B$4:$D$6,3)*B9*HLOOKUP(G$8,$B$4:$D$6,3)","v":4.0000000000000008E-2},1.7999999999999999E-2,6.4000000000000012E-3]
["Stock 2",0.6,1,0.7,null,"Stock 2",1.7999999999999999E-2,2.2499999999999999E-2,8.3999999999999995E-3]
["Stock 3",0.4,0.7,1,null,"Stock 3",6.4000000000000003E-3,8.3999999999999995E-3,6.4000000000000003E-3]
[]
["Investment decisions"]
[null,"Stock 1","Stock 2","Stock 3",null,"Range names used:"]
["Fractions to invest",0.49999748675438199,0,0.50000351324561798,null,"Actual_return","=Model!$B$23"]
[null,null,null,null,null,"Fractions_to_invest","=Model!$B$15:$D$15"]
["Constraint on investing everything",null,null,null,null,"Portfolio_variance","=Model!$B$25"]
[null,"Total invested",null,"Required value",null,"Required_return","=Model!$D$23"]
[null,{"$f":"SUM(B15:D15)","v":1.0000009999999999},"=",1,null,"Total_invested","=Model!$B$19"]
[]
["Constraint on expected portfolio return"]
[null,"Actual return",null,"Required return"]
[null,{"$f":"SUMPRODUCT(B5:D5,Fractions_to_invest)","v":0.11999999947017528},">=",0.12]
[]
["Portfolio variance",{"$f":"MMULT(Fractions_to_invest,MMULT(G9:I11,TRANSPOSE(Fractions_to_invest)))","v":1.4799928355165868E-2}]
["Portfolio stdev",{"$f":"SQRT(Portfolio_variance)","v":0.1216549561471536}]